package com.xialinrui.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xialinrui.dto.DailyMoneyDto;
import com.xialinrui.vo.ExpenditureCategoryVo;
import com.xialinrui.vo.IncomeCategoryVo;
import com.xialinrui.dto.MonthlyMoneyDto;
import com.xialinrui.entity.Replay;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author xialinrui
 */
@Mapper
@Repository
public interface ReplayMapper extends BaseMapper<Replay> {
    List<DailyMoneyDto> moneyDailyIncome(@Param("from") String from,@Param("to") String to);

    List<DailyMoneyDto> moneyDailyExpenditure(@Param("from") String from,@Param("to") String to);

    List<MonthlyMoneyDto> moneyMonthlyIncome(@Param("from") String from,@Param("to") String to);

    List<MonthlyMoneyDto> moneyMonthlyExpenditure(@Param("from") String from,@Param("to") String to);

    List<MonthlyMoneyDto> moneyYearlyIncome(@Param("from") String from,@Param("to") String to);

    List<MonthlyMoneyDto> moneyYearlyExpenditure(@Param("from") String from,@Param("to") String to);

    List<IncomeCategoryVo> incomeByCategory(@Param("from") String from, @Param("to") String to);

    List<ExpenditureCategoryVo> expenditureByCategory(@Param("from") String from, @Param("to") String to);
}
